Role: Sr. BI Data Engineer (DWH ETL) (PL/SQL, Data-marts, Snowflake, SFDC/SOQL/NetSuite) Job Location - San Jose, California (Hybrid - 3 days onsite, 2 day's WFH) Duration: 6 months initial contract W2 only possible extension Job Description: • The candidate should be result-oriented, self-starter and self-motivated who can manage multiple time-sensitive assignments. • Evaluate business requirements, conduct a POC and proactively call out data anomalies within the source system. • Looking for someone in PL/SQL experience, back end working on designing data-warehousing projects. • Develop/performance tune complex SQL designing (PL/SQL and/or T-SQL queries and stored procedures. • Knowledge with Creating Data Solutions, Data marts, Data Layer, DWH/ETL/ Informatica reporting solutions, Some Dash-boarding / Reporting solution(Tableau/PowerBI/ data source) • Knowledge of Commercial Organisations Data (Finance, CRM, Sales, Sales Operations, Marketing • Scripting is a plus like airflow, Crontab but to understand how these scripts work, or Able to batch processes using any bash scripting language like pearl, Unix or python. • Perform end to end data validation for a solution ensuring quality data delivery. • Should be well versed with project tracking tools like Jira and Github . • Candidate should be able to create strategic design and mapping of business requirements to system/technical requirements. • Candidate should be able to communicate, translate, and simplify business requirements to ensure buy-in from all stakeholders. Requirements • Candidate should have experience working with NetSuite objects or Snowflake, SFDC/SOQL or CRM. • 7-10 years of experience with Database Development using Packages/Stored Procedures/Triggers in SQL and PLSQL • 7-10 years of experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD) • 7 years of experience in SQL performance tuning and optimization techniques • Ability to work on on ad-hoc requests and should be able to work on simultaneous projects or tasks • Effective and positive communication and Team working skills.
